﻿--根据某个单位的岗位薪资
CREATE proc [dbo].[proc_Post_GetCompanyPostList]
(
	@companyid int,
	@postcategory int
)
as

	select 
		id,
		postname
	from post 
	where 
	postcategory = @postcategory